package com.ourteam.education.dao;
import java.util.Arrays;
import java.util.List;
import java.util.Map;
import net.dao.BaseQueryBean;
import net.dao.BaseWhereCriterion;
import net.dao.IDataAccessInterface;
import org.apache.commons.lang.StringUtils;
/**
 * Template Name : DAO查询对象
 * Template Version : 1
 * Template Last Modfiy Date : Sat Aug 19 10:06:32 CST 2017
 * Auto Generate Date : 2019-09-22 15:15:09
  * Warning ! This file will be overwrite when regenerate !
  * 
 */
public class ClassStudentRelateDAOQueryBean extends BaseQueryBean {
    
    public ClassStudentRelateDAOQueryBean() {
		super();
    }
	
    public ClassStudentRelateDAOQueryBean(BaseQueryBean aQueryBean) {
        super(aQueryBean);
    }
    
    public ClassStudentRelateDAOQueryBean(BaseQueryBean aQueryBean,Map tableReplaceMap) {
        super(aQueryBean,tableReplaceMap);
    }
    
    public Criteria createCriteria() {
        
	    Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
                  oredCriteria.add(criteria);
            }
        return criteria;
     }
	
    protected Criteria createCriteriaInternal() {
	  return new Criteria(this);
    }
    
        
        
    	
		
	    
    public void addIdSelectProperty(){
		addIdSelectProperty("id");
	}
	
    public void addIdSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IClassStudentRelateDAO.Id,aAlias);
		}
		else{
			addSelectProperty(IClassStudentRelateDAO.Id,"id");
	    }
    }
    
       
		
		
	    
    public void addClassIdSelectProperty(){
		addClassIdSelectProperty("classId");
	}
	
    public void addClassIdSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IClassStudentRelateDAO.ClassId,aAlias);
		}
		else{
			addSelectProperty(IClassStudentRelateDAO.ClassId,"classId");
	    }
    }
    
       
		
		
	    
    public void addStudentIdSelectProperty(){
		addStudentIdSelectProperty("studentId");
	}
	
    public void addStudentIdSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IClassStudentRelateDAO.StudentId,aAlias);
		}
		else{
			addSelectProperty(IClassStudentRelateDAO.StudentId,"studentId");
	    }
    }
    
       
		
		
	    
    public void addRelateTypeSelectProperty(){
		addRelateTypeSelectProperty("relateType");
	}
	
    public void addRelateTypeSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IClassStudentRelateDAO.RelateType,aAlias);
		}
		else{
			addSelectProperty(IClassStudentRelateDAO.RelateType,"relateType");
	    }
    }
    
       
		
		
	    
    public void addDeleteFlagSelectProperty(){
		addDeleteFlagSelectProperty("deleteFlag");
	}
	
    public void addDeleteFlagSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IClassStudentRelateDAO.DeleteFlag,aAlias);
		}
		else{
			addSelectProperty(IClassStudentRelateDAO.DeleteFlag,"deleteFlag");
	    }
    }
    
       
		
		
	    
    public void addStatusSelectProperty(){
		addStatusSelectProperty("status");
	}
	
    public void addStatusSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IClassStudentRelateDAO.Status,aAlias);
		}
		else{
			addSelectProperty(IClassStudentRelateDAO.Status,"status");
	    }
    }
    
       
		
		
	    
    public void addRemarksSelectProperty(){
		addRemarksSelectProperty("remarks");
	}
	
    public void addRemarksSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IClassStudentRelateDAO.Remarks,aAlias);
		}
		else{
			addSelectProperty(IClassStudentRelateDAO.Remarks,"remarks");
	    }
    }
    
       
		
						
	    
    public void addStudentNameSelectProperty(){
		addStudentNameSelectProperty("studentName");
	}
	
    public void addStudentNameSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IClassStudentRelateDAO.StudentName,aAlias);
		}
		else{
			addSelectProperty(IClassStudentRelateDAO.StudentName,"studentName");
	    }
    }
    
    	
				
	    
    public void addStudentGenderSelectProperty(){
		addStudentGenderSelectProperty("studentGender");
	}
	
    public void addStudentGenderSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IClassStudentRelateDAO.StudentGender,aAlias);
		}
		else{
			addSelectProperty(IClassStudentRelateDAO.StudentGender,"studentGender");
	    }
    }
    
    	
				
	    
    public void addContactsRelationSelectProperty(){
		addContactsRelationSelectProperty("contactsRelation");
	}
	
    public void addContactsRelationSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IClassStudentRelateDAO.ContactsRelation,aAlias);
		}
		else{
			addSelectProperty(IClassStudentRelateDAO.ContactsRelation,"contactsRelation");
	    }
    }
    
    	
				
	    
    public void addContactsPhoneSelectProperty(){
		addContactsPhoneSelectProperty("contactsPhone");
	}
	
    public void addContactsPhoneSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IClassStudentRelateDAO.ContactsPhone,aAlias);
		}
		else{
			addSelectProperty(IClassStudentRelateDAO.ContactsPhone,"contactsPhone");
	    }
    }
    
    	
				
	public void addAllSelectProperties(){
		
		
	    addIdSelectProperty();
   
		
		
	    addClassIdSelectProperty();
   
		
		
	    addStudentIdSelectProperty();
   
		
		
	    addRelateTypeSelectProperty();
   
		
		
	    addDeleteFlagSelectProperty();
   
		
		
	    addStatusSelectProperty();
   
		
		
	    addRemarksSelectProperty();
   
		
						
    	addStudentNameSelectProperty();
	
				
    	addStudentGenderSelectProperty();
	
				
    	addContactsRelationSelectProperty();
	
				
    	addContactsPhoneSelectProperty();
	
			    }
    
    public static class Criteria extends BaseWhereCriterion<ClassStudentRelateDAOQueryBean> {
	
        protected Criteria(ClassStudentRelateDAOQueryBean aParentObject) {
		    super(aParentObject);
        }
        
                  
            	
    	    	
    	        
                
        public Criteria andIdIsNull() {
            addCriterion(IClassStudentRelateDAO.Id + " is null");
            return this;
        }
        public Criteria andIdIsNotNull() {
            addCriterion(IClassStudentRelateDAO.Id + " is not null");
            return this;
        }
    
        public Criteria andIdIsNotEmpty() {        
            addCriterion(IClassStudentRelateDAO.Id + " is not null AND " + IClassStudentRelateDAO.Id + " <> ''");
            return this;
        }
    		
    	public Criteria andIdIsEmpty() {       
            addCriterion("(" + IClassStudentRelateDAO.Id + " is null OR " + IClassStudentRelateDAO.Id + " = '')");
            return this;
        }
        
                
                        
                        
                                
        public Criteria andIdEqualTo(long value) {
        	return andIdEqualTo(Long.valueOf(value));
        }
               public Criteria andIdEqualTo(java.lang.Long value) {
        				
            addCriterion(IClassStudentRelateDAO.Id + " = ", value, "id");
            return this;
        }
        
        public Criteria andIdEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.Id);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.Id + " = ", subQueryBean, dao);
			return this;
		}
                
        public Criteria andIdNotEqualTo(long value) {
        	return andIdNotEqualTo(Long.valueOf(value));
        }
                public Criteria andIdNotEqualTo(java.lang.Long value) {
        	        
            addCriterion(IClassStudentRelateDAO.Id + " <>", value, "id");
            return this;
        }
               
        public Criteria andIdNotEqualToOrIsNull(long value) {
        	return andIdNotEqualToOrIsNull(Long.valueOf(value));
        }
                
        public Criteria andIdNotEqualToOrIsNull(java.lang.Long value) {
        	        
            addCriterion(IClassStudentRelateDAO.Id + " is null OR " + IClassStudentRelateDAO.Id + " <>", value, "id");
            return this;
        }
        
        public Criteria andIdNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.Id);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.Id + " <> ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andIdGreaterThan(long value) {
        	return andIdGreaterThan(Long.valueOf(value));
        }
                public Criteria andIdGreaterThan(java.lang.Long value) {
        				
            addCriterion(IClassStudentRelateDAO.Id + " >", value, "id");
            return this;
        }
        
        public Criteria andIdGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.Id);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.Id + " > ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andIdGreaterThanOrEqualTo(long value) {
        	return andIdGreaterThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andIdGreaterThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IClassStudentRelateDAO.Id + " >=", value, "id");
            return this;
        }
        
        public Criteria andIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.Id);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.Id + " >= ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andIdLessThan(long value) {
        	return andIdLessThan(Long.valueOf(value));
        }
                public Criteria andIdLessThan(java.lang.Long value) {
        				
            addCriterion(IClassStudentRelateDAO.Id + " <", value, "id");
            return this;
        }
        
        public Criteria andIdLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.Id);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.Id + " < ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andIdLessThanOrEqualTo(long value) {
        	return andIdLessThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andIdLessThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IClassStudentRelateDAO.Id + " <=", value, "id");
            return this;
        }
        
        public Criteria andIdLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.Id);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.Id + " <= ", subQueryBean, dao);
			return this;
		}
		
		        
                
        public Criteria andIdIn(long[] values) {
        	if(values.length == 1){
        		return andIdEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.Id + " in", values, "id");
            	return this;
            }
        }
        
        public Criteria andIdNotIn(long[] values) {
        	if(values.length == 1){
        		return andIdNotEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.Id + " not in", values, "id");
            	return this;
            }
        }
        
                public Criteria andIdIn(List<java.lang.Long> values) {
        	
        	if(values.size() == 1){
        		return andIdEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.Id + " in", values, "id");
            	return this;
            }
        }
        public Criteria andIdNotIn(List<java.lang.Long> values) {
        	if(values.size() == 1){
        		return andIdNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.Id + " not in", values, "id");
            	return this;
            }
        }
        
        public Criteria andIdIn(java.lang.Long[] values) {
        	
        	if(values.length == 1){
        		return andIdEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.Id + " in", Arrays.asList(values), "id");
            	return this;
            }
        }
        public Criteria andIdNotIn(java.lang.Long[] values) {
        	if(values.length == 1){
        		return andIdNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.Id + " not in", Arrays.asList(values), "id");
            	return this;
            }
        }
		
		public Criteria andIdIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.Id + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andIdNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.Id + " not in ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andIdBetween(long value1,long value2) {
        	addCriterion(IClassStudentRelateDAO.Id + " between", value1, value2, "id");
            return this;
        }
                public Criteria andIdBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IClassStudentRelateDAO.Id + " between", value1, value2, "id");
            return this;
        }
        
                
        public Criteria andIdNotBetween(long value1,long value2) {
        	addCriterion(IClassStudentRelateDAO.Id + " not between", value1, value2, "id");
            return this;
        }
                public Criteria andIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IClassStudentRelateDAO.Id + " not between", value1, value2, "id");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andClassIdIsNull() {
            addCriterion(IClassStudentRelateDAO.ClassId + " is null");
            return this;
        }
        public Criteria andClassIdIsNotNull() {
            addCriterion(IClassStudentRelateDAO.ClassId + " is not null");
            return this;
        }
    
        public Criteria andClassIdIsNotEmpty() {        
            addCriterion(IClassStudentRelateDAO.ClassId + " is not null AND " + IClassStudentRelateDAO.ClassId + " <> ''");
            return this;
        }
    		
    	public Criteria andClassIdIsEmpty() {       
            addCriterion("(" + IClassStudentRelateDAO.ClassId + " is null OR " + IClassStudentRelateDAO.ClassId + " = '')");
            return this;
        }
        
                
                        
                        
                                
        public Criteria andClassIdEqualTo(long value) {
        	return andClassIdEqualTo(Long.valueOf(value));
        }
               public Criteria andClassIdEqualTo(java.lang.Long value) {
        				
            addCriterion(IClassStudentRelateDAO.ClassId + " = ", value, "classId");
            return this;
        }
        
        public Criteria andClassIdEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.ClassId);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andClassIdEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.ClassId + " = ", subQueryBean, dao);
			return this;
		}
                
        public Criteria andClassIdNotEqualTo(long value) {
        	return andClassIdNotEqualTo(Long.valueOf(value));
        }
                public Criteria andClassIdNotEqualTo(java.lang.Long value) {
        	        
            addCriterion(IClassStudentRelateDAO.ClassId + " <>", value, "classId");
            return this;
        }
               
        public Criteria andClassIdNotEqualToOrIsNull(long value) {
        	return andClassIdNotEqualToOrIsNull(Long.valueOf(value));
        }
                
        public Criteria andClassIdNotEqualToOrIsNull(java.lang.Long value) {
        	        
            addCriterion(IClassStudentRelateDAO.ClassId + " is null OR " + IClassStudentRelateDAO.ClassId + " <>", value, "classId");
            return this;
        }
        
        public Criteria andClassIdNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.ClassId);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andClassIdNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.ClassId + " <> ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andClassIdGreaterThan(long value) {
        	return andClassIdGreaterThan(Long.valueOf(value));
        }
                public Criteria andClassIdGreaterThan(java.lang.Long value) {
        				
            addCriterion(IClassStudentRelateDAO.ClassId + " >", value, "classId");
            return this;
        }
        
        public Criteria andClassIdGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.ClassId);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andClassIdGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.ClassId + " > ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andClassIdGreaterThanOrEqualTo(long value) {
        	return andClassIdGreaterThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andClassIdGreaterThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IClassStudentRelateDAO.ClassId + " >=", value, "classId");
            return this;
        }
        
        public Criteria andClassIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.ClassId);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andClassIdGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.ClassId + " >= ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andClassIdLessThan(long value) {
        	return andClassIdLessThan(Long.valueOf(value));
        }
                public Criteria andClassIdLessThan(java.lang.Long value) {
        				
            addCriterion(IClassStudentRelateDAO.ClassId + " <", value, "classId");
            return this;
        }
        
        public Criteria andClassIdLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.ClassId);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andClassIdLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.ClassId + " < ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andClassIdLessThanOrEqualTo(long value) {
        	return andClassIdLessThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andClassIdLessThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IClassStudentRelateDAO.ClassId + " <=", value, "classId");
            return this;
        }
        
        public Criteria andClassIdLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.ClassId);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andClassIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.ClassId + " <= ", subQueryBean, dao);
			return this;
		}
		
		        
                
        public Criteria andClassIdIn(long[] values) {
        	if(values.length == 1){
        		return andClassIdEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.ClassId + " in", values, "classId");
            	return this;
            }
        }
        
        public Criteria andClassIdNotIn(long[] values) {
        	if(values.length == 1){
        		return andClassIdNotEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.ClassId + " not in", values, "classId");
            	return this;
            }
        }
        
                public Criteria andClassIdIn(List<java.lang.Long> values) {
        	
        	if(values.size() == 1){
        		return andClassIdEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.ClassId + " in", values, "classId");
            	return this;
            }
        }
        public Criteria andClassIdNotIn(List<java.lang.Long> values) {
        	if(values.size() == 1){
        		return andClassIdNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.ClassId + " not in", values, "classId");
            	return this;
            }
        }
        
        public Criteria andClassIdIn(java.lang.Long[] values) {
        	
        	if(values.length == 1){
        		return andClassIdEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.ClassId + " in", Arrays.asList(values), "classId");
            	return this;
            }
        }
        public Criteria andClassIdNotIn(java.lang.Long[] values) {
        	if(values.length == 1){
        		return andClassIdNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.ClassId + " not in", Arrays.asList(values), "classId");
            	return this;
            }
        }
		
		public Criteria andClassIdIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.ClassId + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andClassIdNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.ClassId + " not in ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andClassIdBetween(long value1,long value2) {
        	addCriterion(IClassStudentRelateDAO.ClassId + " between", value1, value2, "classId");
            return this;
        }
                public Criteria andClassIdBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IClassStudentRelateDAO.ClassId + " between", value1, value2, "classId");
            return this;
        }
        
                
        public Criteria andClassIdNotBetween(long value1,long value2) {
        	addCriterion(IClassStudentRelateDAO.ClassId + " not between", value1, value2, "classId");
            return this;
        }
                public Criteria andClassIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IClassStudentRelateDAO.ClassId + " not between", value1, value2, "classId");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andStudentIdIsNull() {
            addCriterion(IClassStudentRelateDAO.StudentId + " is null");
            return this;
        }
        public Criteria andStudentIdIsNotNull() {
            addCriterion(IClassStudentRelateDAO.StudentId + " is not null");
            return this;
        }
    
        public Criteria andStudentIdIsNotEmpty() {        
            addCriterion(IClassStudentRelateDAO.StudentId + " is not null AND " + IClassStudentRelateDAO.StudentId + " <> ''");
            return this;
        }
    		
    	public Criteria andStudentIdIsEmpty() {       
            addCriterion("(" + IClassStudentRelateDAO.StudentId + " is null OR " + IClassStudentRelateDAO.StudentId + " = '')");
            return this;
        }
        
                
                        
                        
                                
        public Criteria andStudentIdEqualTo(long value) {
        	return andStudentIdEqualTo(Long.valueOf(value));
        }
               public Criteria andStudentIdEqualTo(java.lang.Long value) {
        				
            addCriterion(IClassStudentRelateDAO.StudentId + " = ", value, "studentId");
            return this;
        }
        
        public Criteria andStudentIdEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.StudentId);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStudentIdEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.StudentId + " = ", subQueryBean, dao);
			return this;
		}
                
        public Criteria andStudentIdNotEqualTo(long value) {
        	return andStudentIdNotEqualTo(Long.valueOf(value));
        }
                public Criteria andStudentIdNotEqualTo(java.lang.Long value) {
        	        
            addCriterion(IClassStudentRelateDAO.StudentId + " <>", value, "studentId");
            return this;
        }
               
        public Criteria andStudentIdNotEqualToOrIsNull(long value) {
        	return andStudentIdNotEqualToOrIsNull(Long.valueOf(value));
        }
                
        public Criteria andStudentIdNotEqualToOrIsNull(java.lang.Long value) {
        	        
            addCriterion(IClassStudentRelateDAO.StudentId + " is null OR " + IClassStudentRelateDAO.StudentId + " <>", value, "studentId");
            return this;
        }
        
        public Criteria andStudentIdNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.StudentId);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStudentIdNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.StudentId + " <> ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andStudentIdGreaterThan(long value) {
        	return andStudentIdGreaterThan(Long.valueOf(value));
        }
                public Criteria andStudentIdGreaterThan(java.lang.Long value) {
        				
            addCriterion(IClassStudentRelateDAO.StudentId + " >", value, "studentId");
            return this;
        }
        
        public Criteria andStudentIdGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.StudentId);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStudentIdGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.StudentId + " > ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andStudentIdGreaterThanOrEqualTo(long value) {
        	return andStudentIdGreaterThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andStudentIdGreaterThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IClassStudentRelateDAO.StudentId + " >=", value, "studentId");
            return this;
        }
        
        public Criteria andStudentIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.StudentId);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStudentIdGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.StudentId + " >= ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andStudentIdLessThan(long value) {
        	return andStudentIdLessThan(Long.valueOf(value));
        }
                public Criteria andStudentIdLessThan(java.lang.Long value) {
        				
            addCriterion(IClassStudentRelateDAO.StudentId + " <", value, "studentId");
            return this;
        }
        
        public Criteria andStudentIdLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.StudentId);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStudentIdLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.StudentId + " < ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andStudentIdLessThanOrEqualTo(long value) {
        	return andStudentIdLessThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andStudentIdLessThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IClassStudentRelateDAO.StudentId + " <=", value, "studentId");
            return this;
        }
        
        public Criteria andStudentIdLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.StudentId);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStudentIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.StudentId + " <= ", subQueryBean, dao);
			return this;
		}
		
		        
                
        public Criteria andStudentIdIn(long[] values) {
        	if(values.length == 1){
        		return andStudentIdEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.StudentId + " in", values, "studentId");
            	return this;
            }
        }
        
        public Criteria andStudentIdNotIn(long[] values) {
        	if(values.length == 1){
        		return andStudentIdNotEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.StudentId + " not in", values, "studentId");
            	return this;
            }
        }
        
                public Criteria andStudentIdIn(List<java.lang.Long> values) {
        	
        	if(values.size() == 1){
        		return andStudentIdEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.StudentId + " in", values, "studentId");
            	return this;
            }
        }
        public Criteria andStudentIdNotIn(List<java.lang.Long> values) {
        	if(values.size() == 1){
        		return andStudentIdNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.StudentId + " not in", values, "studentId");
            	return this;
            }
        }
        
        public Criteria andStudentIdIn(java.lang.Long[] values) {
        	
        	if(values.length == 1){
        		return andStudentIdEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.StudentId + " in", Arrays.asList(values), "studentId");
            	return this;
            }
        }
        public Criteria andStudentIdNotIn(java.lang.Long[] values) {
        	if(values.length == 1){
        		return andStudentIdNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.StudentId + " not in", Arrays.asList(values), "studentId");
            	return this;
            }
        }
		
		public Criteria andStudentIdIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.StudentId + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andStudentIdNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.StudentId + " not in ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andStudentIdBetween(long value1,long value2) {
        	addCriterion(IClassStudentRelateDAO.StudentId + " between", value1, value2, "studentId");
            return this;
        }
                public Criteria andStudentIdBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IClassStudentRelateDAO.StudentId + " between", value1, value2, "studentId");
            return this;
        }
        
                
        public Criteria andStudentIdNotBetween(long value1,long value2) {
        	addCriterion(IClassStudentRelateDAO.StudentId + " not between", value1, value2, "studentId");
            return this;
        }
                public Criteria andStudentIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IClassStudentRelateDAO.StudentId + " not between", value1, value2, "studentId");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andRelateTypeIsNull() {
            addCriterion(IClassStudentRelateDAO.RelateType + " is null");
            return this;
        }
        public Criteria andRelateTypeIsNotNull() {
            addCriterion(IClassStudentRelateDAO.RelateType + " is not null");
            return this;
        }
    
        public Criteria andRelateTypeIsNotEmpty() {        
            addCriterion(IClassStudentRelateDAO.RelateType + " is not null AND " + IClassStudentRelateDAO.RelateType + " <> ''");
            return this;
        }
    		
    	public Criteria andRelateTypeIsEmpty() {       
            addCriterion("(" + IClassStudentRelateDAO.RelateType + " is null OR " + IClassStudentRelateDAO.RelateType + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andRelateTypeEqualTo(String value) {
        				
            addCriterion(IClassStudentRelateDAO.RelateType + " = ", value, "relateType");
            return this;
        }
        
        public Criteria andRelateTypeEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.RelateType);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRelateTypeEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.RelateType + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andRelateTypeNotEqualTo(String value) {
        	        
            addCriterion(IClassStudentRelateDAO.RelateType + " <>", value, "relateType");
            return this;
        }
               
        public Criteria andRelateTypeNotEqualToOrIsNull(String value) {
        	        
            addCriterion(IClassStudentRelateDAO.RelateType + " is null OR " + IClassStudentRelateDAO.RelateType + " <>", value, "relateType");
            return this;
        }
        
        public Criteria andRelateTypeNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.RelateType);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRelateTypeNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.RelateType + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andRelateTypeGreaterThan(String value) {
        				
            addCriterion(IClassStudentRelateDAO.RelateType + " >", value, "relateType");
            return this;
        }
        
        public Criteria andRelateTypeGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.RelateType);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRelateTypeGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.RelateType + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andRelateTypeGreaterThanOrEqualTo(String value) {
        				
            addCriterion(IClassStudentRelateDAO.RelateType + " >=", value, "relateType");
            return this;
        }
        
        public Criteria andRelateTypeGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.RelateType);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRelateTypeGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.RelateType + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andRelateTypeLessThan(String value) {
        				
            addCriterion(IClassStudentRelateDAO.RelateType + " <", value, "relateType");
            return this;
        }
        
        public Criteria andRelateTypeLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.RelateType);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRelateTypeLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.RelateType + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andRelateTypeLessThanOrEqualTo(String value) {
        				
            addCriterion(IClassStudentRelateDAO.RelateType + " <=", value, "relateType");
            return this;
        }
        
        public Criteria andRelateTypeLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.RelateType);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRelateTypeLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.RelateType + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andRelateTypeLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IClassStudentRelateDAO.RelateType + " like", buffer.toString(), "relateType");
            return this;
        }
        public Criteria andRelateTypeNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IClassStudentRelateDAO.RelateType + " not like", buffer.toString(), "relateType");
            return this;
        }
                
                public Criteria andRelateTypeIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andRelateTypeEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.RelateType + " in", values, "relateType");
            	return this;
            }
        }
        public Criteria andRelateTypeNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andRelateTypeNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.RelateType + " not in", values, "relateType");
            	return this;
            }
        }
        
        public Criteria andRelateTypeIn(String[] values) {
        	
        	if(values.length == 1){
        		return andRelateTypeEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.RelateType + " in", Arrays.asList(values), "relateType");
            	return this;
            }
        }
        public Criteria andRelateTypeNotIn(String[] values) {
        	if(values.length == 1){
        		return andRelateTypeNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.RelateType + " not in", Arrays.asList(values), "relateType");
            	return this;
            }
        }
		
		public Criteria andRelateTypeIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.RelateType + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andRelateTypeNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.RelateType + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andRelateTypeBetween(String value1, String value2) {
            addCriterion(IClassStudentRelateDAO.RelateType + " between", value1, value2, "relateType");
            return this;
        }
        
                public Criteria andRelateTypeNotBetween(String value1, String value2) {
            addCriterion(IClassStudentRelateDAO.RelateType + " not between", value1, value2, "relateType");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andDeleteFlagIsNull() {
            addCriterion(IClassStudentRelateDAO.DeleteFlag + " is null");
            return this;
        }
        public Criteria andDeleteFlagIsNotNull() {
            addCriterion(IClassStudentRelateDAO.DeleteFlag + " is not null");
            return this;
        }
    
        public Criteria andDeleteFlagIsNotEmpty() {        
            addCriterion(IClassStudentRelateDAO.DeleteFlag + " is not null AND " + IClassStudentRelateDAO.DeleteFlag + " <> ''");
            return this;
        }
    		
    	public Criteria andDeleteFlagIsEmpty() {       
            addCriterion("(" + IClassStudentRelateDAO.DeleteFlag + " is null OR " + IClassStudentRelateDAO.DeleteFlag + " = '')");
            return this;
        }
        
                
                        
                        
                                
        public Criteria andDeleteFlagEqualTo(long value) {
        	return andDeleteFlagEqualTo(Long.valueOf(value));
        }
               public Criteria andDeleteFlagEqualTo(java.lang.Long value) {
        				
            addCriterion(IClassStudentRelateDAO.DeleteFlag + " = ", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.DeleteFlag);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.DeleteFlag + " = ", subQueryBean, dao);
			return this;
		}
                
        public Criteria andDeleteFlagNotEqualTo(long value) {
        	return andDeleteFlagNotEqualTo(Long.valueOf(value));
        }
                public Criteria andDeleteFlagNotEqualTo(java.lang.Long value) {
        	        
            addCriterion(IClassStudentRelateDAO.DeleteFlag + " <>", value, "deleteFlag");
            return this;
        }
               
        public Criteria andDeleteFlagNotEqualToOrIsNull(long value) {
        	return andDeleteFlagNotEqualToOrIsNull(Long.valueOf(value));
        }
                
        public Criteria andDeleteFlagNotEqualToOrIsNull(java.lang.Long value) {
        	        
            addCriterion(IClassStudentRelateDAO.DeleteFlag + " is null OR " + IClassStudentRelateDAO.DeleteFlag + " <>", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.DeleteFlag);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.DeleteFlag + " <> ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andDeleteFlagGreaterThan(long value) {
        	return andDeleteFlagGreaterThan(Long.valueOf(value));
        }
                public Criteria andDeleteFlagGreaterThan(java.lang.Long value) {
        				
            addCriterion(IClassStudentRelateDAO.DeleteFlag + " >", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.DeleteFlag);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.DeleteFlag + " > ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andDeleteFlagGreaterThanOrEqualTo(long value) {
        	return andDeleteFlagGreaterThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andDeleteFlagGreaterThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IClassStudentRelateDAO.DeleteFlag + " >=", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.DeleteFlag);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.DeleteFlag + " >= ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andDeleteFlagLessThan(long value) {
        	return andDeleteFlagLessThan(Long.valueOf(value));
        }
                public Criteria andDeleteFlagLessThan(java.lang.Long value) {
        				
            addCriterion(IClassStudentRelateDAO.DeleteFlag + " <", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.DeleteFlag);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.DeleteFlag + " < ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andDeleteFlagLessThanOrEqualTo(long value) {
        	return andDeleteFlagLessThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andDeleteFlagLessThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IClassStudentRelateDAO.DeleteFlag + " <=", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.DeleteFlag);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.DeleteFlag + " <= ", subQueryBean, dao);
			return this;
		}
		
		        
                
        public Criteria andDeleteFlagIn(long[] values) {
        	if(values.length == 1){
        		return andDeleteFlagEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.DeleteFlag + " in", values, "deleteFlag");
            	return this;
            }
        }
        
        public Criteria andDeleteFlagNotIn(long[] values) {
        	if(values.length == 1){
        		return andDeleteFlagNotEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.DeleteFlag + " not in", values, "deleteFlag");
            	return this;
            }
        }
        
                public Criteria andDeleteFlagIn(List<java.lang.Long> values) {
        	
        	if(values.size() == 1){
        		return andDeleteFlagEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.DeleteFlag + " in", values, "deleteFlag");
            	return this;
            }
        }
        public Criteria andDeleteFlagNotIn(List<java.lang.Long> values) {
        	if(values.size() == 1){
        		return andDeleteFlagNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.DeleteFlag + " not in", values, "deleteFlag");
            	return this;
            }
        }
        
        public Criteria andDeleteFlagIn(java.lang.Long[] values) {
        	
        	if(values.length == 1){
        		return andDeleteFlagEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.DeleteFlag + " in", Arrays.asList(values), "deleteFlag");
            	return this;
            }
        }
        public Criteria andDeleteFlagNotIn(java.lang.Long[] values) {
        	if(values.length == 1){
        		return andDeleteFlagNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.DeleteFlag + " not in", Arrays.asList(values), "deleteFlag");
            	return this;
            }
        }
		
		public Criteria andDeleteFlagIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.DeleteFlag + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andDeleteFlagNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.DeleteFlag + " not in ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andDeleteFlagBetween(long value1,long value2) {
        	addCriterion(IClassStudentRelateDAO.DeleteFlag + " between", value1, value2, "deleteFlag");
            return this;
        }
                public Criteria andDeleteFlagBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IClassStudentRelateDAO.DeleteFlag + " between", value1, value2, "deleteFlag");
            return this;
        }
        
                
        public Criteria andDeleteFlagNotBetween(long value1,long value2) {
        	addCriterion(IClassStudentRelateDAO.DeleteFlag + " not between", value1, value2, "deleteFlag");
            return this;
        }
                public Criteria andDeleteFlagNotBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IClassStudentRelateDAO.DeleteFlag + " not between", value1, value2, "deleteFlag");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andStatusIsNull() {
            addCriterion(IClassStudentRelateDAO.Status + " is null");
            return this;
        }
        public Criteria andStatusIsNotNull() {
            addCriterion(IClassStudentRelateDAO.Status + " is not null");
            return this;
        }
    
        public Criteria andStatusIsNotEmpty() {        
            addCriterion(IClassStudentRelateDAO.Status + " is not null AND " + IClassStudentRelateDAO.Status + " <> ''");
            return this;
        }
    		
    	public Criteria andStatusIsEmpty() {       
            addCriterion("(" + IClassStudentRelateDAO.Status + " is null OR " + IClassStudentRelateDAO.Status + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andStatusEqualTo(String value) {
        				
            addCriterion(IClassStudentRelateDAO.Status + " = ", value, "status");
            return this;
        }
        
        public Criteria andStatusEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.Status);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.Status + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andStatusNotEqualTo(String value) {
        	        
            addCriterion(IClassStudentRelateDAO.Status + " <>", value, "status");
            return this;
        }
               
        public Criteria andStatusNotEqualToOrIsNull(String value) {
        	        
            addCriterion(IClassStudentRelateDAO.Status + " is null OR " + IClassStudentRelateDAO.Status + " <>", value, "status");
            return this;
        }
        
        public Criteria andStatusNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.Status);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.Status + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andStatusGreaterThan(String value) {
        				
            addCriterion(IClassStudentRelateDAO.Status + " >", value, "status");
            return this;
        }
        
        public Criteria andStatusGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.Status);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.Status + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andStatusGreaterThanOrEqualTo(String value) {
        				
            addCriterion(IClassStudentRelateDAO.Status + " >=", value, "status");
            return this;
        }
        
        public Criteria andStatusGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.Status);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.Status + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andStatusLessThan(String value) {
        				
            addCriterion(IClassStudentRelateDAO.Status + " <", value, "status");
            return this;
        }
        
        public Criteria andStatusLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.Status);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.Status + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andStatusLessThanOrEqualTo(String value) {
        				
            addCriterion(IClassStudentRelateDAO.Status + " <=", value, "status");
            return this;
        }
        
        public Criteria andStatusLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.Status);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.Status + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andStatusLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IClassStudentRelateDAO.Status + " like", buffer.toString(), "status");
            return this;
        }
        public Criteria andStatusNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IClassStudentRelateDAO.Status + " not like", buffer.toString(), "status");
            return this;
        }
                
                public Criteria andStatusIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andStatusEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.Status + " in", values, "status");
            	return this;
            }
        }
        public Criteria andStatusNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andStatusNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.Status + " not in", values, "status");
            	return this;
            }
        }
        
        public Criteria andStatusIn(String[] values) {
        	
        	if(values.length == 1){
        		return andStatusEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.Status + " in", Arrays.asList(values), "status");
            	return this;
            }
        }
        public Criteria andStatusNotIn(String[] values) {
        	if(values.length == 1){
        		return andStatusNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.Status + " not in", Arrays.asList(values), "status");
            	return this;
            }
        }
		
		public Criteria andStatusIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.Status + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andStatusNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.Status + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andStatusBetween(String value1, String value2) {
            addCriterion(IClassStudentRelateDAO.Status + " between", value1, value2, "status");
            return this;
        }
        
                public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion(IClassStudentRelateDAO.Status + " not between", value1, value2, "status");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andRemarksIsNull() {
            addCriterion(IClassStudentRelateDAO.Remarks + " is null");
            return this;
        }
        public Criteria andRemarksIsNotNull() {
            addCriterion(IClassStudentRelateDAO.Remarks + " is not null");
            return this;
        }
    
        public Criteria andRemarksIsNotEmpty() {        
            addCriterion(IClassStudentRelateDAO.Remarks + " is not null AND " + IClassStudentRelateDAO.Remarks + " <> ''");
            return this;
        }
    		
    	public Criteria andRemarksIsEmpty() {       
            addCriterion("(" + IClassStudentRelateDAO.Remarks + " is null OR " + IClassStudentRelateDAO.Remarks + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andRemarksEqualTo(String value) {
        				
            addCriterion(IClassStudentRelateDAO.Remarks + " = ", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.Remarks);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.Remarks + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andRemarksNotEqualTo(String value) {
        	        
            addCriterion(IClassStudentRelateDAO.Remarks + " <>", value, "remarks");
            return this;
        }
               
        public Criteria andRemarksNotEqualToOrIsNull(String value) {
        	        
            addCriterion(IClassStudentRelateDAO.Remarks + " is null OR " + IClassStudentRelateDAO.Remarks + " <>", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.Remarks);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.Remarks + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andRemarksGreaterThan(String value) {
        				
            addCriterion(IClassStudentRelateDAO.Remarks + " >", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.Remarks);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.Remarks + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andRemarksGreaterThanOrEqualTo(String value) {
        				
            addCriterion(IClassStudentRelateDAO.Remarks + " >=", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.Remarks);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.Remarks + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andRemarksLessThan(String value) {
        				
            addCriterion(IClassStudentRelateDAO.Remarks + " <", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.Remarks);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.Remarks + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andRemarksLessThanOrEqualTo(String value) {
        				
            addCriterion(IClassStudentRelateDAO.Remarks + " <=", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.Remarks);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.Remarks + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andRemarksLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IClassStudentRelateDAO.Remarks + " like", buffer.toString(), "remarks");
            return this;
        }
        public Criteria andRemarksNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IClassStudentRelateDAO.Remarks + " not like", buffer.toString(), "remarks");
            return this;
        }
                
                public Criteria andRemarksIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andRemarksEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.Remarks + " in", values, "remarks");
            	return this;
            }
        }
        public Criteria andRemarksNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andRemarksNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.Remarks + " not in", values, "remarks");
            	return this;
            }
        }
        
        public Criteria andRemarksIn(String[] values) {
        	
        	if(values.length == 1){
        		return andRemarksEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.Remarks + " in", Arrays.asList(values), "remarks");
            	return this;
            }
        }
        public Criteria andRemarksNotIn(String[] values) {
        	if(values.length == 1){
        		return andRemarksNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.Remarks + " not in", Arrays.asList(values), "remarks");
            	return this;
            }
        }
		
		public Criteria andRemarksIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.Remarks + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andRemarksNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.Remarks + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andRemarksBetween(String value1, String value2) {
            addCriterion(IClassStudentRelateDAO.Remarks + " between", value1, value2, "remarks");
            return this;
        }
        
                public Criteria andRemarksNotBetween(String value1, String value2) {
            addCriterion(IClassStudentRelateDAO.Remarks + " not between", value1, value2, "remarks");
            return this;
        }
        
            	
    	    	
    	    	    	    	    	    	
                
                
        public Criteria andStudentNameIsNull() {
            addCriterion(IClassStudentRelateDAO.StudentName + " is null");
            return this;
        }
        public Criteria andStudentNameIsNotNull() {
            addCriterion(IClassStudentRelateDAO.StudentName + " is not null");
            return this;
        }
    
        public Criteria andStudentNameIsNotEmpty() {        
            addCriterion(IClassStudentRelateDAO.StudentName + " is not null AND " + IClassStudentRelateDAO.StudentName + " <> ''");
            return this;
        }
    		
    	public Criteria andStudentNameIsEmpty() {       
            addCriterion("(" + IClassStudentRelateDAO.StudentName + " is null OR " + IClassStudentRelateDAO.StudentName + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andStudentNameEqualTo(String value) {
        				
            addCriterion(IClassStudentRelateDAO.StudentName + " = ", value, "studentName");
            return this;
        }
        
        public Criteria andStudentNameEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.StudentName);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStudentNameEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.StudentName + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andStudentNameNotEqualTo(String value) {
        	        
            addCriterion(IClassStudentRelateDAO.StudentName + " <>", value, "studentName");
            return this;
        }
               
        public Criteria andStudentNameNotEqualToOrIsNull(String value) {
        	        
            addCriterion(IClassStudentRelateDAO.StudentName + " is null OR " + IClassStudentRelateDAO.StudentName + " <>", value, "studentName");
            return this;
        }
        
        public Criteria andStudentNameNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.StudentName);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStudentNameNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.StudentName + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andStudentNameGreaterThan(String value) {
        				
            addCriterion(IClassStudentRelateDAO.StudentName + " >", value, "studentName");
            return this;
        }
        
        public Criteria andStudentNameGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.StudentName);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStudentNameGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.StudentName + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andStudentNameGreaterThanOrEqualTo(String value) {
        				
            addCriterion(IClassStudentRelateDAO.StudentName + " >=", value, "studentName");
            return this;
        }
        
        public Criteria andStudentNameGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.StudentName);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStudentNameGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.StudentName + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andStudentNameLessThan(String value) {
        				
            addCriterion(IClassStudentRelateDAO.StudentName + " <", value, "studentName");
            return this;
        }
        
        public Criteria andStudentNameLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.StudentName);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStudentNameLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.StudentName + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andStudentNameLessThanOrEqualTo(String value) {
        				
            addCriterion(IClassStudentRelateDAO.StudentName + " <=", value, "studentName");
            return this;
        }
        
        public Criteria andStudentNameLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.StudentName);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStudentNameLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.StudentName + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andStudentNameLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IClassStudentRelateDAO.StudentName + " like", buffer.toString(), "studentName");
            return this;
        }
        public Criteria andStudentNameNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IClassStudentRelateDAO.StudentName + " not like", buffer.toString(), "studentName");
            return this;
        }
                
                public Criteria andStudentNameIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andStudentNameEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.StudentName + " in", values, "studentName");
            	return this;
            }
        }
        public Criteria andStudentNameNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andStudentNameNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.StudentName + " not in", values, "studentName");
            	return this;
            }
        }
        
        public Criteria andStudentNameIn(String[] values) {
        	
        	if(values.length == 1){
        		return andStudentNameEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.StudentName + " in", Arrays.asList(values), "studentName");
            	return this;
            }
        }
        public Criteria andStudentNameNotIn(String[] values) {
        	if(values.length == 1){
        		return andStudentNameNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.StudentName + " not in", Arrays.asList(values), "studentName");
            	return this;
            }
        }
		
		public Criteria andStudentNameIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.StudentName + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andStudentNameNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.StudentName + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andStudentNameBetween(String value1, String value2) {
            addCriterion(IClassStudentRelateDAO.StudentName + " between", value1, value2, "studentName");
            return this;
        }
        
                public Criteria andStudentNameNotBetween(String value1, String value2) {
            addCriterion(IClassStudentRelateDAO.StudentName + " not between", value1, value2, "studentName");
            return this;
        }
        
            	
    	    	    	    	
                
                
        public Criteria andStudentGenderIsNull() {
            addCriterion(IClassStudentRelateDAO.StudentGender + " is null");
            return this;
        }
        public Criteria andStudentGenderIsNotNull() {
            addCriterion(IClassStudentRelateDAO.StudentGender + " is not null");
            return this;
        }
    
        public Criteria andStudentGenderIsNotEmpty() {        
            addCriterion(IClassStudentRelateDAO.StudentGender + " is not null AND " + IClassStudentRelateDAO.StudentGender + " <> ''");
            return this;
        }
    		
    	public Criteria andStudentGenderIsEmpty() {       
            addCriterion("(" + IClassStudentRelateDAO.StudentGender + " is null OR " + IClassStudentRelateDAO.StudentGender + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andStudentGenderEqualTo(String value) {
        				
            addCriterion(IClassStudentRelateDAO.StudentGender + " = ", value, "studentGender");
            return this;
        }
        
        public Criteria andStudentGenderEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.StudentGender);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStudentGenderEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.StudentGender + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andStudentGenderNotEqualTo(String value) {
        	        
            addCriterion(IClassStudentRelateDAO.StudentGender + " <>", value, "studentGender");
            return this;
        }
               
        public Criteria andStudentGenderNotEqualToOrIsNull(String value) {
        	        
            addCriterion(IClassStudentRelateDAO.StudentGender + " is null OR " + IClassStudentRelateDAO.StudentGender + " <>", value, "studentGender");
            return this;
        }
        
        public Criteria andStudentGenderNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.StudentGender);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStudentGenderNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.StudentGender + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andStudentGenderGreaterThan(String value) {
        				
            addCriterion(IClassStudentRelateDAO.StudentGender + " >", value, "studentGender");
            return this;
        }
        
        public Criteria andStudentGenderGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.StudentGender);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStudentGenderGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.StudentGender + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andStudentGenderGreaterThanOrEqualTo(String value) {
        				
            addCriterion(IClassStudentRelateDAO.StudentGender + " >=", value, "studentGender");
            return this;
        }
        
        public Criteria andStudentGenderGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.StudentGender);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStudentGenderGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.StudentGender + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andStudentGenderLessThan(String value) {
        				
            addCriterion(IClassStudentRelateDAO.StudentGender + " <", value, "studentGender");
            return this;
        }
        
        public Criteria andStudentGenderLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.StudentGender);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStudentGenderLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.StudentGender + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andStudentGenderLessThanOrEqualTo(String value) {
        				
            addCriterion(IClassStudentRelateDAO.StudentGender + " <=", value, "studentGender");
            return this;
        }
        
        public Criteria andStudentGenderLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.StudentGender);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStudentGenderLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.StudentGender + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andStudentGenderLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IClassStudentRelateDAO.StudentGender + " like", buffer.toString(), "studentGender");
            return this;
        }
        public Criteria andStudentGenderNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IClassStudentRelateDAO.StudentGender + " not like", buffer.toString(), "studentGender");
            return this;
        }
                
                public Criteria andStudentGenderIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andStudentGenderEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.StudentGender + " in", values, "studentGender");
            	return this;
            }
        }
        public Criteria andStudentGenderNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andStudentGenderNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.StudentGender + " not in", values, "studentGender");
            	return this;
            }
        }
        
        public Criteria andStudentGenderIn(String[] values) {
        	
        	if(values.length == 1){
        		return andStudentGenderEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.StudentGender + " in", Arrays.asList(values), "studentGender");
            	return this;
            }
        }
        public Criteria andStudentGenderNotIn(String[] values) {
        	if(values.length == 1){
        		return andStudentGenderNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.StudentGender + " not in", Arrays.asList(values), "studentGender");
            	return this;
            }
        }
		
		public Criteria andStudentGenderIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.StudentGender + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andStudentGenderNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.StudentGender + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andStudentGenderBetween(String value1, String value2) {
            addCriterion(IClassStudentRelateDAO.StudentGender + " between", value1, value2, "studentGender");
            return this;
        }
        
                public Criteria andStudentGenderNotBetween(String value1, String value2) {
            addCriterion(IClassStudentRelateDAO.StudentGender + " not between", value1, value2, "studentGender");
            return this;
        }
        
            	
    	    	    	    	
                
                
        public Criteria andContactsRelationIsNull() {
            addCriterion(IClassStudentRelateDAO.ContactsRelation + " is null");
            return this;
        }
        public Criteria andContactsRelationIsNotNull() {
            addCriterion(IClassStudentRelateDAO.ContactsRelation + " is not null");
            return this;
        }
    
        public Criteria andContactsRelationIsNotEmpty() {        
            addCriterion(IClassStudentRelateDAO.ContactsRelation + " is not null AND " + IClassStudentRelateDAO.ContactsRelation + " <> ''");
            return this;
        }
    		
    	public Criteria andContactsRelationIsEmpty() {       
            addCriterion("(" + IClassStudentRelateDAO.ContactsRelation + " is null OR " + IClassStudentRelateDAO.ContactsRelation + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andContactsRelationEqualTo(String value) {
        				
            addCriterion(IClassStudentRelateDAO.ContactsRelation + " = ", value, "contactsRelation");
            return this;
        }
        
        public Criteria andContactsRelationEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.ContactsRelation);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andContactsRelationEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.ContactsRelation + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andContactsRelationNotEqualTo(String value) {
        	        
            addCriterion(IClassStudentRelateDAO.ContactsRelation + " <>", value, "contactsRelation");
            return this;
        }
               
        public Criteria andContactsRelationNotEqualToOrIsNull(String value) {
        	        
            addCriterion(IClassStudentRelateDAO.ContactsRelation + " is null OR " + IClassStudentRelateDAO.ContactsRelation + " <>", value, "contactsRelation");
            return this;
        }
        
        public Criteria andContactsRelationNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.ContactsRelation);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andContactsRelationNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.ContactsRelation + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andContactsRelationGreaterThan(String value) {
        				
            addCriterion(IClassStudentRelateDAO.ContactsRelation + " >", value, "contactsRelation");
            return this;
        }
        
        public Criteria andContactsRelationGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.ContactsRelation);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andContactsRelationGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.ContactsRelation + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andContactsRelationGreaterThanOrEqualTo(String value) {
        				
            addCriterion(IClassStudentRelateDAO.ContactsRelation + " >=", value, "contactsRelation");
            return this;
        }
        
        public Criteria andContactsRelationGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.ContactsRelation);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andContactsRelationGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.ContactsRelation + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andContactsRelationLessThan(String value) {
        				
            addCriterion(IClassStudentRelateDAO.ContactsRelation + " <", value, "contactsRelation");
            return this;
        }
        
        public Criteria andContactsRelationLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.ContactsRelation);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andContactsRelationLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.ContactsRelation + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andContactsRelationLessThanOrEqualTo(String value) {
        				
            addCriterion(IClassStudentRelateDAO.ContactsRelation + " <=", value, "contactsRelation");
            return this;
        }
        
        public Criteria andContactsRelationLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.ContactsRelation);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andContactsRelationLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.ContactsRelation + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andContactsRelationLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IClassStudentRelateDAO.ContactsRelation + " like", buffer.toString(), "contactsRelation");
            return this;
        }
        public Criteria andContactsRelationNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IClassStudentRelateDAO.ContactsRelation + " not like", buffer.toString(), "contactsRelation");
            return this;
        }
                
                public Criteria andContactsRelationIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andContactsRelationEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.ContactsRelation + " in", values, "contactsRelation");
            	return this;
            }
        }
        public Criteria andContactsRelationNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andContactsRelationNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.ContactsRelation + " not in", values, "contactsRelation");
            	return this;
            }
        }
        
        public Criteria andContactsRelationIn(String[] values) {
        	
        	if(values.length == 1){
        		return andContactsRelationEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.ContactsRelation + " in", Arrays.asList(values), "contactsRelation");
            	return this;
            }
        }
        public Criteria andContactsRelationNotIn(String[] values) {
        	if(values.length == 1){
        		return andContactsRelationNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.ContactsRelation + " not in", Arrays.asList(values), "contactsRelation");
            	return this;
            }
        }
		
		public Criteria andContactsRelationIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.ContactsRelation + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andContactsRelationNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.ContactsRelation + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andContactsRelationBetween(String value1, String value2) {
            addCriterion(IClassStudentRelateDAO.ContactsRelation + " between", value1, value2, "contactsRelation");
            return this;
        }
        
                public Criteria andContactsRelationNotBetween(String value1, String value2) {
            addCriterion(IClassStudentRelateDAO.ContactsRelation + " not between", value1, value2, "contactsRelation");
            return this;
        }
        
            	
    	    	    	    	
                
                
        public Criteria andContactsPhoneIsNull() {
            addCriterion(IClassStudentRelateDAO.ContactsPhone + " is null");
            return this;
        }
        public Criteria andContactsPhoneIsNotNull() {
            addCriterion(IClassStudentRelateDAO.ContactsPhone + " is not null");
            return this;
        }
    
        public Criteria andContactsPhoneIsNotEmpty() {        
            addCriterion(IClassStudentRelateDAO.ContactsPhone + " is not null AND " + IClassStudentRelateDAO.ContactsPhone + " <> ''");
            return this;
        }
    		
    	public Criteria andContactsPhoneIsEmpty() {       
            addCriterion("(" + IClassStudentRelateDAO.ContactsPhone + " is null OR " + IClassStudentRelateDAO.ContactsPhone + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andContactsPhoneEqualTo(String value) {
        				
            addCriterion(IClassStudentRelateDAO.ContactsPhone + " = ", value, "contactsPhone");
            return this;
        }
        
        public Criteria andContactsPhoneEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.ContactsPhone);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andContactsPhoneEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.ContactsPhone + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andContactsPhoneNotEqualTo(String value) {
        	        
            addCriterion(IClassStudentRelateDAO.ContactsPhone + " <>", value, "contactsPhone");
            return this;
        }
               
        public Criteria andContactsPhoneNotEqualToOrIsNull(String value) {
        	        
            addCriterion(IClassStudentRelateDAO.ContactsPhone + " is null OR " + IClassStudentRelateDAO.ContactsPhone + " <>", value, "contactsPhone");
            return this;
        }
        
        public Criteria andContactsPhoneNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.ContactsPhone);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andContactsPhoneNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.ContactsPhone + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andContactsPhoneGreaterThan(String value) {
        				
            addCriterion(IClassStudentRelateDAO.ContactsPhone + " >", value, "contactsPhone");
            return this;
        }
        
        public Criteria andContactsPhoneGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IClassStudentRelateDAO.ContactsPhone);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andContactsPhoneGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.ContactsPhone + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andContactsPhoneGreaterThanOrEqualTo(String value) {
        				
            addCriterion(IClassStudentRelateDAO.ContactsPhone + " >=", value, "contactsPhone");
            return this;
        }
        
        public Criteria andContactsPhoneGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.ContactsPhone);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andContactsPhoneGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.ContactsPhone + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andContactsPhoneLessThan(String value) {
        				
            addCriterion(IClassStudentRelateDAO.ContactsPhone + " <", value, "contactsPhone");
            return this;
        }
        
        public Criteria andContactsPhoneLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.ContactsPhone);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andContactsPhoneLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.ContactsPhone + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andContactsPhoneLessThanOrEqualTo(String value) {
        				
            addCriterion(IClassStudentRelateDAO.ContactsPhone + " <=", value, "contactsPhone");
            return this;
        }
        
        public Criteria andContactsPhoneLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IClassStudentRelateDAO.ContactsPhone);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andContactsPhoneLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.ContactsPhone + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andContactsPhoneLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IClassStudentRelateDAO.ContactsPhone + " like", buffer.toString(), "contactsPhone");
            return this;
        }
        public Criteria andContactsPhoneNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IClassStudentRelateDAO.ContactsPhone + " not like", buffer.toString(), "contactsPhone");
            return this;
        }
                
                public Criteria andContactsPhoneIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andContactsPhoneEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.ContactsPhone + " in", values, "contactsPhone");
            	return this;
            }
        }
        public Criteria andContactsPhoneNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andContactsPhoneNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.ContactsPhone + " not in", values, "contactsPhone");
            	return this;
            }
        }
        
        public Criteria andContactsPhoneIn(String[] values) {
        	
        	if(values.length == 1){
        		return andContactsPhoneEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.ContactsPhone + " in", Arrays.asList(values), "contactsPhone");
            	return this;
            }
        }
        public Criteria andContactsPhoneNotIn(String[] values) {
        	if(values.length == 1){
        		return andContactsPhoneNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IClassStudentRelateDAO.ContactsPhone + " not in", Arrays.asList(values), "contactsPhone");
            	return this;
            }
        }
		
		public Criteria andContactsPhoneIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.ContactsPhone + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andContactsPhoneNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IClassStudentRelateDAO.ContactsPhone + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andContactsPhoneBetween(String value1, String value2) {
            addCriterion(IClassStudentRelateDAO.ContactsPhone + " between", value1, value2, "contactsPhone");
            return this;
        }
        
                public Criteria andContactsPhoneNotBetween(String value1, String value2) {
            addCriterion(IClassStudentRelateDAO.ContactsPhone + " not between", value1, value2, "contactsPhone");
            return this;
        }
        
            	
    	    	    	        
        
    }
	
    
}